Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	167803
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	260
Duplicate rows (%)	0.2%
Total size in memory	23.0 MiB
Average record size in memory	144.0 B

Variable types

Numeric	14
Categorical	3

Alerts

Dataset has 260 (0.2%) duplicate rows	Duplicates
`C_WTHR` is highly overall correlated with `C_RSUR`	High correlation
`C_RSUR` is highly overall correlated with `C_WTHR`	High correlation
`V_TYPE` is highly overall correlated with `P_USER`	High correlation
`P_PSN` is highly overall correlated with `P_USER`	High correlation
`P_USER` is highly overall correlated with `V_TYPE` and 1 other fields	High correlation
`P_USER` is highly imbalanced (50.4%)	Imbalance
`C_HOUR` has 2012 (1.2%) zeros	Zeros

Reproduction

Analysis started	2023-03-29 20:29:13.180914
Analysis finished	2023-03-29 20:31:19.347863
Duration	2 minutes and 6.17 seconds
Software version	ydata-profiling vv4.1.1
Download configuration	config.json

C_MNTH
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.6972223

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4216502
Coefficient of variation (CV)	0.51090586
Kurtosis	-1.1483379
Mean	6.6972223
Median Absolute Deviation (MAD)	3
Skewness	-0.12319989
Sum	1123814
Variance	11.70769
Monotonicity	Increasing

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	15878	9.5%
8	15866	9.5%
10	15408	9.2%
6	15203	9.1%
9	14549	8.7%
1	14491	8.6%
11	14207	8.5%
12	14191	8.5%
5	12948	7.7%
2	12539	7.5%
Other values (2)	22523	13.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	14491	8.6%
2	12539	7.5%
3	11469	6.8%
4	11054	6.6%
5	12948	7.7%
6	15203	9.1%
7	15878	9.5%
8	15866	9.5%
9	14549	8.7%
10	15408	9.2%

Value	Count	Frequency (%)
12	14191	8.5%
11	14207	8.5%
10	15408	9.2%
9	14549	8.7%
8	15866	9.5%
7	15878	9.5%
6	15203	9.1%
5	12948	7.7%
4	11054	6.6%
3	11469	6.8%

C_WDAY
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9458949

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.937695
Coefficient of variation (CV)	0.49106605
Kurtosis	-1.1794702
Mean	3.9458949
Median Absolute Deviation (MAD)	2
Skewness	0.0037620051
Sum	662133
Variance	3.7546619
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
5	27685	16.5%
4	25386	15.1%
3	24264	14.5%
2	24132	14.4%
1	23375	13.9%
6	22994	13.7%
7	19967	11.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	23375	13.9%
2	24132	14.4%
3	24264	14.5%
4	25386	15.1%
5	27685	16.5%
6	22994	13.7%
7	19967	11.9%

Value	Count	Frequency (%)
7	19967	11.9%
6	22994	13.7%
5	27685	16.5%
4	25386	15.1%
3	24264	14.5%
2	24132	14.4%
1	23375	13.9%

C_HOUR
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.698968

Minimum	0
Maximum	23
Zeros	2012
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	10
median	14
Q3	17
95-th percentile	21
Maximum	23
Range	23
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.9486293
Coefficient of variation (CV)	0.36124101
Kurtosis	-0.12933708
Mean	13.698968
Median Absolute Deviation (MAD)	3
Skewness	-0.44699837
Sum	2298728
Variance	24.488932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
16	15550	9.3%
17	14886	8.9%
15	14266	8.5%
14	11871	7.1%
12	10944	6.5%
18	10836	6.5%
13	10774	6.4%
8	9013	5.4%
11	8813	5.3%
19	7801	4.6%
Other values (14)	53049	31.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2012	1.2%
1	1584	0.9%
2	1200	0.7%
3	1046	0.6%
4	871	0.5%
5	1639	1.0%
6	3947	2.4%
7	6940	4.1%
8	9013	5.4%
9	7366	4.4%

Value	Count	Frequency (%)
23	3188	1.9%
22	4163	2.5%
21	5411	3.2%
20	6026	3.6%
19	7801	4.6%
18	10836	6.5%
17	14886	8.9%
16	15550	9.3%
15	14266	8.5%
14	11871	7.1%

C_VEHS
Real number (ℝ)

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1603845

Minimum	1
Maximum	38
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	4
Maximum	38
Range	37
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.4799538
Coefficient of variation (CV)	0.68504187
Kurtosis	249.85121
Mean	2.1603845
Median Absolute Deviation (MAD)	0
Skewness	12.824219
Sum	362519
Variance	2.1902634
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
2	106537	63.5%
1	28986	17.3%
3	22982	13.7%
4	6132	3.7%
5	1545	0.9%
6	578	0.3%
7	216	0.1%
8	143	0.1%
10	119	0.1%
38	73	< 0.1%
Other values (15)	492	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	28986	17.3%
2	106537	63.5%
3	22982	13.7%
4	6132	3.7%
5	1545	0.9%
6	578	0.3%
7	216	0.1%
8	143	0.1%
9	48	< 0.1%
10	119	0.1%

Value	Count	Frequency (%)
38	73	< 0.1%
33	38	< 0.1%
28	11	< 0.1%
27	26	< 0.1%
25	44	< 0.1%
24	25	< 0.1%
23	25	< 0.1%
20	39	< 0.1%
18	23	< 0.1%
17	26	< 0.1%

C_CONF
Real number (ℝ)

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.895079

Minimum	1
Maximum	41
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	21
median	21
Q3	35
95-th percentile	36
Maximum	41
Range	40
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	11.013946
Coefficient of variation (CV)	0.46092944
Kurtosis	-0.73813967
Mean	23.895079
Median Absolute Deviation (MAD)	12
Skewness	-0.59179004
Sum	4009666
Variance	121.307
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
21	56141	33.5%
35	26594	15.8%
36	21505	12.8%
6	15195	9.1%
33	13154	7.8%
22	6514	3.9%
31	6093	3.6%
4	5286	3.2%
2	4508	2.7%
3	3672	2.2%
Other values (8)	9141	5.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1121	0.7%
2	4508	2.7%
3	3672	2.2%
4	5286	3.2%
5	441	0.3%
6	15195	9.1%
21	56141	33.5%
22	6514	3.9%
23	1919	1.1%
24	1372	0.8%

Value	Count	Frequency (%)
41	1233	0.7%
36	21505	12.8%
35	26594	15.8%
34	942	0.6%
33	13154	7.8%
32	1617	1.0%
31	6093	3.6%
25	496	0.3%
24	1372	0.8%
23	1919	1.1%

C_RCFG
Real number (ℝ)

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6524973

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	10
Range	9
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.78652683
Coefficient of variation (CV)	0.47596256
Kurtosis	22.567922
Mean	1.6524973
Median Absolute Deviation (MAD)	0
Skewness	3.2741607
Sum	277294
Variance	0.61862446
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	84076	50.1%
1	74596	44.5%
3	6502	3.9%
5	1413	0.8%
8	409	0.2%
4	399	0.2%
6	196	0.1%
9	156	0.1%
10	45	< 0.1%
7	11	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	74596	44.5%
2	84076	50.1%
3	6502	3.9%
4	399	0.2%
5	1413	0.8%
6	196	0.1%
7	11	< 0.1%
8	409	0.2%
9	156	0.1%
10	45	< 0.1%

Value	Count	Frequency (%)
10	45	< 0.1%
9	156	0.1%
8	409	0.2%
7	11	< 0.1%
6	196	0.1%
5	1413	0.8%
4	399	0.2%
3	6502	3.9%
2	84076	50.1%
1	74596	44.5%

C_WTHR
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5804425

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	4
Maximum	7
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1647745
Coefficient of variation (CV)	0.7369926
Kurtosis	4.5246439
Mean	1.5804425
Median Absolute Deviation (MAD)	0
Skewness	2.1991351
Sum	265203
Variance	1.3566995
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	124704	74.3%
3	14682	8.7%
2	13381	8.0%
4	9926	5.9%
6	3381	2.0%
5	1201	0.7%
7	528	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	124704	74.3%
2	13381	8.0%
3	14682	8.7%
4	9926	5.9%
5	1201	0.7%
6	3381	2.0%
7	528	0.3%

Value	Count	Frequency (%)
7	528	0.3%
6	3381	2.0%
5	1201	0.7%
4	9926	5.9%
3	14682	8.7%
2	13381	8.0%
1	124704	74.3%

C_RSUR
Real number (ℝ)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5840778

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	5
Maximum	9
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1291563
Coefficient of variation (CV)	0.71281621
Kurtosis	3.9545715
Mean	1.5840778
Median Absolute Deviation (MAD)	0
Skewness	2.1741378
Sum	265813
Variance	1.274994
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	117752	70.2%
2	27928	16.6%
5	10530	6.3%
3	8134	4.8%
4	2877	1.7%
6	478	0.3%
7	67	< 0.1%
8	25	< 0.1%
9	12	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	117752	70.2%
2	27928	16.6%
3	8134	4.8%
4	2877	1.7%
5	10530	6.3%
6	478	0.3%
7	67	< 0.1%
8	25	< 0.1%
9	12	< 0.1%

Value	Count	Frequency (%)
9	12	< 0.1%
8	25	< 0.1%
7	67	< 0.1%
6	478	0.3%
5	10530	6.3%
4	2877	1.7%
3	8134	4.8%
2	27928	16.6%
1	117752	70.2%

C_RALN
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.381048

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	3
Maximum	6
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.9192379
Coefficient of variation (CV)	0.66560894
Kurtosis	7.9543948
Mean	1.381048
Median Absolute Deviation (MAD)	0
Skewness	2.7917864
Sum	231744
Variance	0.84499832
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	135463	80.7%
2	13818	8.2%
3	10362	6.2%
4	4750	2.8%
5	1901	1.1%
6	1509	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	135463	80.7%
2	13818	8.2%
3	10362	6.2%
4	4750	2.8%
5	1901	1.1%
6	1509	0.9%

Value	Count	Frequency (%)
6	1509	0.9%
5	1901	1.1%
4	4750	2.8%
3	10362	6.2%
2	13818	8.2%
1	135463	80.7%

C_TRAF
Real number (ℝ)

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.129849

Minimum	1
Maximum	18
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	18
Q3	18
95-th percentile	18
Maximum	18
Range	17
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	8.1474628
Coefficient of variation (CV)	0.80430252
Kurtosis	-1.9566678
Mean	10.129849
Median Absolute Deviation (MAD)	0
Skewness	-0.092600371
Sum	1699819
Variance	66.38115
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
18	85985	51.2%
1	54410	32.4%
3	21898	13.0%
4	2481	1.5%
6	855	0.5%
2	679	0.4%
8	544	0.3%
12	318	0.2%
11	181	0.1%
13	117	0.1%
Other values (7)	335	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	54410	32.4%
2	679	0.4%
3	21898	13.0%
4	2481	1.5%
5	58	< 0.1%
6	855	0.5%
7	38	< 0.1%
8	544	0.3%
9	14	< 0.1%
10	55	< 0.1%

Value	Count	Frequency (%)
18	85985	51.2%
17	28	< 0.1%
16	55	< 0.1%
15	87	0.1%
13	117	0.1%
12	318	0.2%
11	181	0.1%
10	55	< 0.1%
9	14	< 0.1%
8	544	0.3%

V_TYPE
Real number (ℝ)

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.7890264

Minimum	1
Maximum	23
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	8
Maximum	23
Range	22
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.6866716
Coefficient of variation (CV)	1.5017507
Kurtosis	13.705601
Mean	1.7890264
Median Absolute Deviation (MAD)	0
Skewness	3.6963727
Sum	300204
Variance	7.2182043
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
1	152017	90.6%
14	4052	2.4%
7	2576	1.5%
6	2482	1.5%
8	2081	1.2%
11	1736	1.0%
5	1663	1.0%
9	789	0.5%
17	198	0.1%
23	67	< 0.1%
Other values (3)	142	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	152017	90.6%
5	1663	1.0%
6	2482	1.5%
7	2576	1.5%
8	2081	1.2%
9	789	0.5%
10	29	< 0.1%
11	1736	1.0%
14	4052	2.4%
17	198	0.1%

Value	Count	Frequency (%)
23	67	< 0.1%
21	48	< 0.1%
18	65	< 0.1%
17	198	0.1%
14	4052	2.4%
11	1736	1.0%
10	29	< 0.1%
9	789	0.5%
8	2081	1.2%
7	2576	1.5%

V_YEAR
Real number (ℝ)

Distinct	70
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2011.0704

Minimum	1918
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1918
5-th percentile	2001
Q1	2007
median	2012
Q3	2016
95-th percentile	2018
Maximum	2020
Range	102
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	5.8519295
Coefficient of variation (CV)	0.0029098582
Kurtosis	9.3068141
Mean	2011.0704
Median Absolute Deviation (MAD)	4
Skewness	-1.4219074
Sum	3.3746364 × 10⁸
Variance	34.245079
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2017	13046	7.8%
2018	12632	7.5%
2015	11499	6.9%
2016	11450	6.8%
2014	10953	6.5%
2013	10477	6.2%
2010	9825	5.9%
2012	9607	5.7%
2008	9243	5.5%
2007	9108	5.4%
Other values (60)	59963	35.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1918	1	< 0.1%
1920	16	< 0.1%
1927	2	< 0.1%
1938	2	< 0.1%
1947	3	< 0.1%
1950	2	< 0.1%
1951	2	< 0.1%
1954	1	< 0.1%
1955	1	< 0.1%
1956	1	< 0.1%

Value	Count	Frequency (%)
2020	556	0.3%
2019	7498	4.5%
2018	12632	7.5%
2017	13046	7.8%
2016	11450	6.8%
2015	11499	6.9%
2014	10953	6.5%
2013	10477	6.2%
2012	9607	5.7%
2011	8326	5.0%

P_SEX
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

1	91295
0	76508

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	167803
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	91295	54.4%
0	76508	45.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	91295	54.4%
0	76508	45.6%

Most occurring characters

Value	Count	Frequency (%)
1	91295	54.4%
0	76508	45.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	167803	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	91295	54.4%
0	76508	45.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	167803	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	91295	54.4%
0	76508	45.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	167803	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	91295	54.4%
0	76508	45.6%

P_AGE
Real number (ℝ)

Distinct	99
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39.325137

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	10
Q1	24
median	37
Q3	54
95-th percentile	73
Maximum	99
Range	98
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	19.446134
Coefficient of variation (CV)	0.49449629
Kurtosis	-0.61830736
Mean	39.325137
Median Absolute Deviation (MAD)	15
Skewness	0.29869703
Sum	6598876
Variance	378.15214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19	3872	2.3%
21	3852	2.3%
20	3840	2.3%
18	3819	2.3%
23	3803	2.3%
22	3801	2.3%
24	3639	2.2%
25	3623	2.2%
26	3573	2.1%
27	3513	2.1%
Other values (89)	130468	77.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1936	1.2%
2	753	0.4%
3	730	0.4%
4	705	0.4%
5	743	0.4%
6	764	0.5%
7	726	0.4%
8	742	0.4%
9	780	0.5%
10	730	0.4%

Value	Count	Frequency (%)
99	9	< 0.1%
98	14	< 0.1%
97	8	< 0.1%
96	7	< 0.1%
95	13	< 0.1%
94	29	< 0.1%
93	54	< 0.1%
92	60	< 0.1%
91	77	< 0.1%
90	123	0.1%

P_PSN
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.120427

Minimum	11
Maximum	98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	11
5-th percentile	11
Q1	11
median	11
Q3	13
95-th percentile	23
Maximum	98
Range	87
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	7.9328005
Coefficient of variation (CV)	0.60461451
Kurtosis	83.184396
Mean	13.120427
Median Absolute Deviation (MAD)	0
Skewness	8.4253462
Sum	2201647
Variance	62.929324
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
11	123673	73.7%
13	23861	14.2%
23	7889	4.7%
21	6518	3.9%
22	1993	1.2%
12	1610	1.0%
96	1168	0.7%
32	694	0.4%
33	199	0.1%
31	160	0.1%
Other values (2)	38	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	123673	73.7%
12	1610	1.0%
13	23861	14.2%
21	6518	3.9%
22	1993	1.2%
23	7889	4.7%
31	160	0.1%
32	694	0.4%
33	199	0.1%
96	1168	0.7%

Value	Count	Frequency (%)
98	11	< 0.1%
97	27	< 0.1%
96	1168	0.7%
33	199	0.1%
32	694	0.4%
31	160	0.1%
23	7889	4.7%
22	1993	1.2%
21	6518	3.9%
13	23861	14.2%

P_ISEV
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

2	90299
1	76530
3	974

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	167803
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	1
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
2	90299	53.8%
1	76530	45.6%
3	974	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	90299	53.8%
1	76530	45.6%
3	974	0.6%

Most occurring characters

Value	Count	Frequency (%)
2	90299	53.8%
1	76530	45.6%
3	974	0.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	167803	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	90299	53.8%
1	76530	45.6%
3	974	0.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	167803	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	90299	53.8%
1	76530	45.6%
3	974	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	167803	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	90299	53.8%
1	76530	45.6%
3	974	0.6%

P_USER
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

1	120061
2	43492
5	4052
4	198

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	167803
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	2
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	120061	71.5%
2	43492	25.9%
5	4052	2.4%
4	198	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	120061	71.5%
2	43492	25.9%
5	4052	2.4%
4	198	0.1%

Most occurring characters

Value	Count	Frequency (%)
1	120061	71.5%
2	43492	25.9%
5	4052	2.4%
4	198	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	167803	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	120061	71.5%
2	43492	25.9%
5	4052	2.4%
4	198	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	167803	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	120061	71.5%
2	43492	25.9%
5	4052	2.4%
4	198	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	167803	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	120061	71.5%
2	43492	25.9%
5	4052	2.4%
4	198	0.1%

Auto

Heatmap
Table

	C_MNTH	C_WDAY	C_HOUR	C_VEHS	C_CONF	C_RCFG	C_WTHR	C_RSUR	C_RALN	C_TRAF	V_TYPE	V_YEAR	P_AGE	P_PSN	P_SEX	P_ISEV	P_USER
C_MNTH	1.000	0.014	0.006	-0.011	0.003	0.009	-0.035	-0.121	-0.007	-0.002	0.000	0.048	0.010	0.003	0.006	0.014	0.082
C_WDAY	0.014	1.000	-0.081	-0.039	0.022	-0.012	-0.026	-0.042	0.020	-0.001	-0.033	-0.004	-0.034	0.084	0.000	0.003	0.067
C_HOUR	0.006	-0.081	1.000	-0.050	0.022	-0.028	0.028	0.051	0.009	-0.014	-0.004	-0.005	-0.074	-0.024	0.089	0.058	0.053
C_VEHS	-0.011	-0.039	-0.050	1.000	-0.360	0.060	-0.062	-0.088	-0.132	-0.087	-0.061	0.100	0.033	0.001	0.024	0.038	0.014
C_CONF	0.003	0.022	0.022	-0.360	1.000	0.187	-0.007	0.041	0.019	0.012	0.028	-0.030	0.003	-0.000	0.057	0.156	0.107
C_RCFG	0.009	-0.012	-0.028	0.060	0.187	1.000	-0.072	-0.073	-0.105	-0.165	-0.039	0.010	0.041	0.002	0.039	0.066	0.024
C_WTHR	-0.035	-0.026	0.028	-0.062	-0.007	-0.072	1.000	0.656	0.099	0.030	0.001	-0.032	-0.026	-0.002	0.015	0.033	0.034
C_RSUR	-0.121	-0.042	0.051	-0.088	0.041	-0.073	0.656	1.000	0.100	0.033	-0.018	-0.031	-0.031	-0.009	0.010	0.042	0.066
C_RALN	-0.007	0.020	0.009	-0.132	0.019	-0.105	0.099	0.100	1.000	0.116	0.066	-0.065	-0.035	0.016	0.020	0.071	0.040
C_TRAF	-0.002	-0.001	-0.014	-0.087	0.012	-0.165	0.030	0.033	0.116	1.000	0.031	-0.025	-0.009	0.005	0.041	0.070	0.036
V_TYPE	0.000	-0.033	-0.004	-0.061	0.028	-0.039	0.001	-0.018	0.066	0.031	1.000	-0.017	0.032	-0.017	0.180	0.123	0.819
V_YEAR	0.048	-0.004	-0.005	0.100	-0.030	0.010	-0.032	-0.031	-0.065	-0.025	-0.017	1.000	0.032	0.026	0.083	0.058	0.093
P_AGE	0.010	-0.034	-0.074	0.033	0.003	0.041	-0.026	-0.031	-0.035	-0.009	0.032	0.032	1.000	-0.161	0.043	0.068	0.292
P_PSN	0.003	0.084	-0.024	0.001	-0.000	0.002	-0.002	-0.009	0.016	0.005	-0.017	0.026	-0.161	1.000	0.171	0.051	0.582
P_SEX	0.006	0.000	0.089	0.024	0.057	0.039	0.015	0.010	0.020	0.041	0.180	0.083	0.043	0.171	1.000	0.159	0.177
P_ISEV	0.014	0.003	0.058	0.038	0.156	0.066	0.033	0.042	0.071	0.070	0.123	0.058	0.068	0.051	0.159	1.000	0.098
P_USER	0.082	0.067	0.053	0.014	0.107	0.024	0.034	0.066	0.040	0.036	0.819	0.093	0.292	0.582	0.177	0.098	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	C_MNTH	C_WDAY	C_HOUR	C_VEHS	C_CONF	C_RCFG	C_WTHR	C_RSUR	C_RALN	C_TRAF	V_TYPE	V_YEAR	P_SEX	P_AGE	P_PSN	P_ISEV	P_USER
2	1	1	11	2	32	1	1	5	4	18	1	2010	0	30	11	2	1
4	1	1	16	2	32	1	2	5	3	18	1	2007	0	27	11	2	1
5	1	1	16	2	32	1	2	5	3	18	1	2007	0	5	33	1	2
6	1	1	16	2	32	1	2	5	3	18	1	2009	1	18	11	2	1
7	1	1	20	1	4	1	2	2	1	12	1	2011	1	38	11	2	1
10	1	1	21	2	2	1	1	2	1	12	1	2007	1	23	11	1	1
11	1	1	21	2	2	1	1	2	1	12	1	2007	0	23	13	1	2
12	1	1	21	2	2	1	1	2	1	12	1	2010	0	49	11	2	1
13	1	1	16	2	33	2	2	2	1	1	1	2006	1	64	11	2	1
33	1	1	13	1	4	1	1	2	1	18	1	2010	0	36	11	2	1

	C_MNTH	C_WDAY	C_HOUR	C_VEHS	C_CONF	C_RCFG	C_WTHR	C_RSUR	C_RALN	C_TRAF	V_TYPE	V_YEAR	P_SEX	P_AGE	P_PSN	P_ISEV	P_USER
272285	12	7	21	2	33	2	1	1	1	1	1	2006	1	74	11	2	1
272286	12	7	21	2	33	2	1	1	1	1	1	2007	0	59	11	1	1
272287	12	7	14	2	33	2	1	1	1	1	1	2001	1	64	11	1	1
272288	12	7	14	2	33	2	1	1	1	1	1	2008	0	46	11	2	1
272292	12	7	23	2	35	2	2	2	1	1	1	2016	0	39	11	1	1
272293	12	7	23	2	35	2	2	2	1	1	1	2016	1	38	12	2	2
272294	12	7	23	2	35	2	2	2	1	1	1	2011	1	30	11	2	1
272295	12	7	17	2	35	2	1	1	1	3	1	2009	0	16	11	2	1
272296	12	7	17	2	35	2	1	1	1	3	1	2009	0	16	13	2	2
272297	12	7	17	2	35	2	1	1	1	3	1	2005	1	81	11	1	1

Most frequently occurring

	C_MNTH	C_WDAY	C_HOUR	C_VEHS	C_CONF	C_RCFG	C_WTHR	C_RSUR	C_RALN	C_TRAF	V_TYPE	V_YEAR	P_SEX	P_AGE	P_PSN	P_ISEV	P_USER	# duplicates
165	9	1	7	3	22	1	1	1	1	18	9	2013	0	14	23	1	2	9
5	1	1	8	2	31	1	1	1	1	18	9	2019	1	14	32	1	2	6
107	5	6	21	3	36	2	1	1	1	1	9	2006	1	23	22	1	2	6
186	9	3	16	2	33	2	1	1	1	3	9	2009	0	15	22	1	2	6
1	1	1	8	2	31	1	1	1	1	18	9	2019	0	14	32	1	2	5
7	1	1	8	2	31	1	1	1	1	18	9	2019	1	17	32	1	2	5
20	1	2	15	2	35	2	1	1	1	3	9	2014	1	8	96	1	2	5
104	5	6	21	3	36	2	1	1	1	1	9	2006	0	22	22	1	2	5
164	9	1	7	3	22	1	1	1	1	18	9	2013	0	14	21	1	2	5
199	10	1	16	3	33	1	3	2	1	18	9	2008	0	14	96	1	2	5

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring